Tabela LPersonnelType

Definicja tabeli LPersonnelType

Name

LPersonnelType

Code

LPersonnelType

Comment

PL: Okreslenie typu personelu
EN: Designation of personel type


Lista kolumn tabeli LPersonnelType

Name

Code

LPersonnelTypeID

LPersonnelTypeID

PersonnelTypeID

PersonnelTypeID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna LPersonnelTypeID tabeli LPersonnelType

Definicja kolumny LPersonnelTypeID tabeli LPersonnelType

Name

LPersonnelTypeID

Code

LPersonnelTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelTypeID tabeli LPersonnelType

Definicja kolumny PersonnelTypeID tabeli LPersonnelType

Name

PersonnelTypeID

Code

PersonnelTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli LPersonnelType

Definicja kolumny PersonID tabeli LPersonnelType

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LPersonnelType

Definicja kolumny StartDT tabeli LPersonnelType

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LPersonnelType

Definicja kolumny StopDT tabeli LPersonnelType

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli LPersonnelType

Definicja kolumny Active tabeli LPersonnelType

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Lista kluczy tabeli LPersonnelType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPersonnelType

Definicja klucza Identifier_1 tabeli LPersonnelType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment